<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
    <meta http-equiv="Content-Style-Type" content="text/css" />
    <!-- MOTW-DISABLED saved from url=(0014)about:internet -->
    <title>Add credit limit data to the report</title>
    <link rel="StyleSheet" href="css/grouping.css" type="text/css" media="all" />
    <link rel="StyleSheet" href="css/webworks.css" type="text/css" media="all" />
    <link rel="StyleSheet" href="webworks.css" type="text/css" media="all" />
    <script type="text/javascript" language="JavaScript1.2">
      <!--
        var  WebWorksRootPath = "";
      // -->
    </script>
  </head>
  <body>
    <div style="text-align: left;">
      <table cellspacing="0" summary="">
        <tr>
          <td>
            <a href="sg-TutT3AddTheCreditLimitFieldToTheDataSet.html"><img src="images/prev.gif" alt="Previous" border="0" /></a>
          </td>
          <td>
            <a href="sg-TutT5GroupCustomerDataByCreditLimit.html"><img src="images/next.gif" alt="Next" border="0" /></a>
          </td>
        </tr>
      </table>
    </div>
    <hr align="left" />
    <blockquote>
      <h3 class="N_TutorialTask">Task 4:&nbsp;&nbsp;<a name="304067">Add credit limit data to the report</a></h3>
      <p class="b_Body"><a name="194981">Use this procedure to insert the credit limit field in the existing table.</a></p>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <span class="zAuto_0023Format">1&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="194982">In the layout editor, select the table by selecting the Table tab. Guide cells appear at the top and left side of the table.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <span class="zAuto_0023Format">2&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="290353">Right-click the guide cell above the first column, then choose Insert</a><span class="Dingbat">&rarr;</span>Column to the Left, as shown in <a href="#290362" title="Add credit limit data to the report">Figure&nbsp;7-3</a>.</div>
            </td>
          </tr>
        </table>
      </div>
      <p class="i2_Image2"><a name="290360"><img class="Default" src="images/grpt_layout2.png" style="display: inline; float: none; left: 0.0; top: 0.0" alt="Figure 7-3 Inserting a column to the left of an existing column" /></a></p>
      <div class="fc2_FigCall2Title">
        <b class="Bold">Figure&nbsp;7-3&nbsp;&nbsp;</b><a name="290362">Inserting a column to the left of an existing column</a></div>
      <div class="N_i_Indent1"><a name="235063">A new column appears.</a></div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <span class="zAuto_0023Format">3&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="304072">Drag the CREDITLIMIT field from Data Explorer, and drop it in the detail row cell next to [CUSTOMERNAME]. </a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_i_Indent1"><a name="374098">In the layout editor, the table displays the added field, as shown in </a><a href="#290338" title="Add credit limit data to the report">Figure&nbsp;7-4</a>. The table also shows the label element that the layout editor automatically added to the header row. This label serves as the column heading and displays the field name as static text.</div>
      <p class="i2_Image2"><a name="304080"><img class="Default" src="images/grpt_layout3.png" style="display: inline; float: none; left: 0.0; top: 0.0" alt="Figure 7-4 Result of adding the credit limit field in the layout editor" /></a></p>
      <div class="fc2_FigCall2Title">
        <b class="Bold">Figure&nbsp;7-4&nbsp;&nbsp;</b><a name="290338">Result of adding the credit limit field in the layout editor</a></div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <span class="zAuto_0023Format">4&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="192186">Edit the CREDITLIMIT label so that it displays</a><span style="font-weight: bold"> </span>Credit Limit.</div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <span class="zAuto_0023Format">5&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="336306">Format the Credit Limit label to look like the other labels in the table header.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n2f_NumList2-First_outer" style="margin-left: 14.1732283464567pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n2f_NumList2-First_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <span class="zAuto_0023FormatGray">1&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n2f_NumList2-First_inner"><a name="336324">Right-click the Customer label, and select Copy Format.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n2_NumList2_outer" style="margin-left: 14.1732283464567pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n2_NumList2_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <span class="zAuto_0023FormatGray">2&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n2_NumList2_inner"><a name="336317">Right-click the Credit Limit label, and select Paste Format.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <span class="zAuto_0023Format">6&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="290421">Preview the report. The report should look like the one shown in </a><a href="#290430" title="Add credit limit data to the report">Figure&nbsp;7-5</a>.</div>
            </td>
          </tr>
        </table>
      </div>
      <p class="i2_Image2"><a name="290428"><img class="Default" src="images/grpt_output1.png" style="display: inline; float: none; left: 0.0; top: 0.0" alt="Figure 7-5 Report preview showing the result of adding credit limit" /></a></p>
      <div class="fc2_FigCall2Title">
        <b class="Bold">Figure&nbsp;7-5&nbsp;&nbsp;</b><a name="290430">Report preview showing the result of adding credit limit</a></div>
      <div class="N_i_Indent1"><a name="192201">Some of the customers have a credit limit of 0. These are new customers who have not yet been approved for a line of credit.</a></div>
    </blockquote>
    <hr align="left" />
    <table align="right" summary="">
      <tr>
        <td class="WebWorks_Company_Name_Bottom">
          <a href="notices.html">(c) Copyright Actuate Corporation 2013</a>
        </td>
      </tr>
    </table>
  </body>
</html>